<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateB2cListsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        //b2c列表
        Schema::create('b2c_lists', function (Blueprint $table) {
            $table->increments('id');
            //库存分配状态
            $table->string('inventory_allocation_status1')->nullable();
            //线下处理状态
            $table->string('offline_processing_status')->nullable();
            //提示    
            $table->string('hint')->nullable();
            //是否冻结  
            $table->string('is_freeze')->nullable();
            //单据类型  
            $table->string('invoices_type')->nullable();
            //订单编号  
            $table->string('order_num')->nullable();
            //订单日期  
            $table->string('order_date')->nullable();
            //会员名称  
            $table->string('member_name')->nullable();
            //来源网店  
            $table->string('source_online_shop')->nullable();
            //来源订单号 
            $table->string('source_order_num')->nullable();
            //单据状态  
            $table->string('invoices_status')->nullable();
            //交易状态  
            $table->string('deal_status')->nullable();
            //关闭状态  
            $table->string('closure_status')->nullable();
            //买家留言  
            $table->string('buyer_leave_word')->nullable();
            //卖家备注  
            $table->string('seller_remark')->nullable();
            //备注    
            $table->string('remark')->nullable();
            //虚拟订单  
            $table->string('virtual_order')->nullable();
            //是否开票  
            $table->string('is_invoice')->nullable();
            //价税合计  
            $table->string('price_tax_summation')->nullable();
            //运费    
            $table->string('freight')->nullable();
            //应支付金额 
            $table->string('due_money')->nullable();
            //已到帐金额 
            $table->string('collected_balances')->nullable();
            //付款时间  
            $table->string('paid_at')->nullable();
            //库存分配状态
            $table->string('inventory_allocation_status2')->nullable();
            //套件数量  
            $table->string('combo_quantity')->nullable();
            //物料条码  
            $table->string('material_code')->nullable();
            //物料编码  
            $table->string('material_num')->nullable();
            //物料名称  
            $table->string('material_name')->nullable();
            //规格型号  
            $table->string('specifications')->nullable();
            //单位    
            $table->string('unit')->nullable();
            //数量    
            $table->string('quantity')->nullable();
            //赠品    
            $table->string('gift')->nullable();
            //含税单价 
            $table->string('unit_price')->nullable();
            //折扣率   
            $table->string('discount_rate')->nullable();
            //折扣额   
            $table->string('deduction')->nullable();
            //净价    
            $table->string('net_price')->nullable();
            //套件编码  
            $table->string('combo_code')->nullable();
            //套件名称  
            $table->string('combo_name')->nullable();
            // $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::drop('b2c_lists');
    }
}
